﻿CREATE TABLE [dbo].[QuoteLineItem_Tbl] (
    [QuoteLineItemID]          INT            IDENTITY (1, 1) NOT NULL,
    [QuoteID]                  INT            NULL,
    [LineItem]                 INT            NULL,
    [QuoteSailtypeID]          INT            NULL,
    [Luff]                     FLOAT          NULL,
    [LPorFoot]                 FLOAT          NULL,
    [InputArea]                FLOAT          NULL,
    [GenericYarnID]            INT            NULL,
    [BoatSpeed]                FLOAT          NULL,
    [AWS]                      INT            NULL,
    [FilmTypeID]               INT            NULL,
    [DPIID]                    INT            NULL,
    [CurrencyID]               INT            NULL,
    [Discount]                 FLOAT          NULL,
    [TierID]                   INT            NULL,
    [UsageID]                  INT            NULL,
    [Createdate]               NVARCHAR (50)  NULL,
    [ConstructionID]           INT            NULL,
    [Price]                    FLOAT          NULL,
    [SailModelCode]            NVARCHAR (50)  NULL,
    [Cut]                      NVARCHAR (50)  NULL,
    [Weight]                   NVARCHAR (50)  NULL,
    [Multiple]                 INT            NULL,
    [TotalPrice]               FLOAT          NULL,
    [TotalOfferedPrice]        FLOAT          NULL,
    [AccessoryID]              INT            NULL,
    [PreDiscountPrice]         FLOAT          NULL,
    [SailNumber]               NVARCHAR (50)  NULL,
    [SailNumberColourID]       INT            NULL,
    [AccessoryColourID]        INT            NULL,
    [NylonColourDetails]       INT            NULL,
    [FixedOfferPrice]          FLOAT          NULL,
    [BRP]                      FLOAT          NULL,
    [ExRate]                   FLOAT          NULL,
    [FabricID]                 INT            NULL,
    [NewBRP]                   FLOAT          NULL,
    [NotionalArea]             BIT            NULL,
    [AccessAttachLineitem]     INT            NULL,
    [TopSurfaceID]             INT            NULL,
    [BotSurfaceID]             INT            NULL,
    [AccessoryItemID]          INT            NULL,
    [DKKPrice]                 FLOAT          NULL,
    [MarketPriceEuro]          FLOAT          NULL,
    [MarketRetailPrice]        FLOAT          NULL,
    [SeasonalPriceEuro]        FLOAT          NULL,
    [SeasonalPriceCurr]        FLOAT          NULL,
    [OptionTotal]              FLOAT          NULL,
    [BillingPrice]             FLOAT          NULL,
    [BillingDiscount]          FLOAT          NULL,
    [BillingCurrency]          NVARCHAR (50)  NULL,
    [OEMSailListID]            INT            NULL,
    [OriginatingOEMSailListID] INT            NULL,
    [COM]                      FLOAT          NULL,
    [DesignFile]               NVARCHAR (50)  NULL,
    [AxItem]                   NVARCHAR (50)  NULL,
    [Notes]                    NVARCHAR (MAX) NULL,
    [NotArea]                  FLOAT          NULL,
    [DeliveryDate]             DATETIME       NULL,
    [DepartmentID]             INT            NULL,
    [LocaleID]                 INT            NULL,
    [AttachedToLineItem]       INT            NULL,
    [HasAttachment]            BIT            NULL,
    [PreviousQuoteLineItemID]  INT            NULL,
    [SailMeasurementID]        INT            NULL,
    [OfferIncVat]              BIT            NULL,
    [ConvertToOrder]           BIT            NULL
);

